package pe.gob.sedapal.scmultimedia.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

import pe.gob.sedapal.scmultimedia.domain.Calle;

public interface CalleDAO {
	@Select(value="{call PKG_SCM.LISTAR_CALLE_POR_LOCAL(" +
			"#{codLocal, mode=IN}," +
			"#{result,  mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=resultCalle})}")
	@Options(statementType = StatementType.CALLABLE)
	List<Calle> listarCallesPorLocalidad(Map<String, Object> parameter);
}
